Configuring the task template and parameters: Oracle

This section discusses how to configure the task template and parameters for Oracle. For information on how to configure the task template and parameters for SQL Server, see Configuring the task template and parameters: SQL Server.

The Active Storage Manager installation process creates a new task type, template, and parameters in the IEE Task Management subsystem.

Important! Active Storage Manager only supports using the DefaultActiveStorageManager template. Do not create any additional templates for Active Storage Manager.

  1. Go to System Operations > Task Management > Task Templates.

  2. From the Task Type dropdown menu, select Active Storage Manager. The Task Template field will automatically populate to DefaultActiveStorageManager.

  3. Complete the fields in the Storage Tier 1, 2, and 3 sections as follows:

    Table 78 Active Storage Manager Parameters

    Parameter Name

    Description

    Required

    Allowed Values

    Storage Tier 1

    Name

    A short name which identifies this tier.

    Yes

    Any alphanumeric string 100 characters or less.

    Retention Months

    Number of months to retain data on this tier.

    Yes

    An integer > 0.

    Storage Tier 2

    Name

    A short name which identifies this tier.

    Yes

    Any alphanumeric string 100 characters or less.

    Suffix Appended to Tier 1 Data Area

    A short tag to be appended to the base data area (tablespace / filegroup) name.

    Yes

    Any combination of letters, numbers, or underscores. Length is only limited by the platform dependent maximum length of a data area name .

    Retention Months

    Number of months to retain data on this tier.

    Required only if Storage Tier 3 is configured.

    An integer > 0.

    Compression Level

    The level of compression which should be applied when moving data onto this storage tier.

    No

    Basic, Advanced, None (default is None).

    The specific compression methods for each of these levels varies depending on platform. See note below.

    Mark as Read Only

    Should partitions be marked as read-only when moved onto this tier.

    No

    True, False (default is False).

    Storage Tier 3

    Name

    A short name which identifies this tier.

    Required if the remaining Storage Tier 3 parameters are specified.

    Any alphanumeric string 100 characters or less.

    Suffix Appended to Tier-2 Data Area

    A short tag to be appended to the base data area (tablespace / filegroup) name.

    Required if Storage Tier 3 Name is configured

    Any combination of letters, numbers, or underscores. Length is only limited by the platform dependent maximum length of a data area name .

    Compression Level

    The level of compression which should be applied when moving data onto this storage tier.

    No

    Basic, Advanced, None (default is None).

    The specific compression methods for each of these levels varies depending on platform. See note below.

    Mark as Read Only

    Should partitions be marked as read-only when moved onto this tier.

    No

    True, False (default is False).

    Command Timeout (in seconds)

    Time to run the Active Storage Manager task.

    Yes

    Time in seconds.

    Note: The compression level values are configured for the following Oracle-specific compression clauses.

    Table 79 Oracle-specific Compression Clauses

    Parameter Value

    Compression Clause

    Basic

    ROW STORE COMPRESS BASIC

    Advanced

    ROW STORE COMPRESS ADVANCED

    None

    n/a

    Configuring the task template and parameters for Oracle.

  4. Click Save.